OMNIS 7 V3.6.3 Patch README.TXT December 23, 1997 IMPORTANT NOTES: This patch fixes specific problems that were reported against all platform versions of OMNIS 7 V3.6, the 3.6.1 Patch for the Macintosh and Power Macintosh platforms, and the 3.6.2 Patch for all platforms. The files contained in this patch can only be used to replace certain V3.6.x files, is available only to licensees of OMNIS 7 V3.6 and therefore licensed under the same terms and conditions set forth in the OMNIS 7 V3.6 product packaging. Web Enabler and Web RAD: 1. Installing this patch on top of a Web Enabled version of OMNIS 7 V3.6 replaces the TCPSock external in your External/Omnis Extensions folder only; it does not replace copies of the file elsewhere on your system. Previous Windows 95 and Windows NT versions of Web Enabler or Web RAD may include a file called either TCPSock32.dll or TCPSoc32.dll. The file is called TCPSock32.dll in this patch regardless of the name of the previous version. 2. Installing this patch on top of a Web Enabled version of OMNIS 7 V3.6 for Windows 95 and Windows NT replaces the FTPCLN32.DLL external in your External folder only; it does not replace copies of the file elsewhere on your system. This new extension fixes a problem with the 'FTPList()' command discovered in the Windows 95 and Windows NT versions reported by one customer. (See ST/EC/223FC below.) CONTENTS ---------------- 1. Installation Instructions 2. Faults Fixed 2.1 Faults Fixed in 7.3.6.3 2.2 Faults Fixed in 7.3.6.2 2.3 Faults Fixed in 7.3.6.1 3. Notes and Cautions 1. Installation Instructions -------------------------------- To install the 3.6.3 Patch: 1. Open the appropriate folder for the platform on which you wish to install. 2. Select either the development or runtime folder as appropriate. 3. Launch the Setup/Install utility located in this folder. 4. Follow the instructions in the installer. This will include entering your OMNIS 7 serialization details. You are now ready to use the OMNIS 7 V3.6.3 Patch. Installation Notes: 1. The Uninstall option for the Windows OS versions removes only the files supplied in this patch, not the whole of OMNIS 7. 2. The 3.6.3 Patch installs a new Serial.exe for all platforms that provides the added convenience of reserialising the OMNIS executable after installation. If you have a text file containing: drive/path/name User Name Company Name Serial Number and drag this file onto Serial.exe, it will reserialise the executable for you. For example: c:/programs/omnis/omnis7.exe George Bailey Bailey Thrift & Loan CMDSI 123456 54321 2. Faults Fixed ------------------ This section describes the fixes for both the 7.3.6.3 Patch, the 7.3.6.2 Patch, and the 7.3.6.1 Patch. The Fixes and Notes contain a reference number such as "OC/RU/412FC" which identifies the problem in the OMNIS Software faults database. Some faults may have a different prefix, such as "ST" for OMNIS Studio faults; but these apply equally to OMNIS 7, when noted, and have been fixed in this release. 2.1 Faults Fixed in the OMNIS 7.3.6.3 Patch ------------------------------------------------- OC/AH/101FC Platform(s): All All calculated fields specified in an Ad hoc report are now used to sort the report. OC/AH/102FC Platform(s): All Ad hoc reports that join two or more tables now execute correctly in design mode. OC/ET/077 Platform(s): All A fix in 7.3.6.2 for external areas has been reversed. Hence the xfcsetup message sets up the field name and reference correctly as in 7.3.6.1 and earlier versions. OC/PC/207FC Platform(s): Windows 95 and Windows NT The bottom margin of a report is no longer affected when using the 'Begin print job' and 'End print job' commands when printing multiple reports in a batch. OC/PF/078FC Platform(s): Mac OS The speed of redrawing fields on windows containing 200 or more objects has been improved. OC/WO/682 Platform(s): All Horizontal scroll bars in entry fields inside table objects now function correctly. ST/EC/223FC Platform(s): Windows 95 and Windows NT The FTPList() command no longer results in errors when running in conjunction with an Windows NT 4.0 FTP Server in which OMNIS and the OMNIS application were invoked multiple times over short time intervals, such as a few clock ticks to several seconds. 2.2 Faults Fixed in the OMNIS 7.3.6.2 Patch ------------------------------------------------------ This section contains a cumulative list of faults fixed since the release of both OMNIS 7 V3.6 for all platforms and the 3.6.1 Patch for the Macintosh and Power Macintosh platforms. PR/@O/040FC Platform(s): All The Oracle DAM now handles select tables returned using Oracle stored procedures. Although Oracle can return select tables with multiple columns through stored procedures, it does not allow multi-column arrays to be bound to multi-column tables. Oracle limits binding to tables to one column only. Therefore, to return a select table through a stored procedure each column of the select table must be passed back as a separate parameter to the procedure. To bind a column of a list to a stored procedure you must use the following syntax: :list_name[(num_rows)].col_name where num_rows is the maximum number of rows in the list to bind. If the procedure returns more rows than there are allocated an error will result. If you don't specify the number of rows, a default value is used. OC/@O/072 Platform(s): All Adding the size of buffer after an updateable bind variable in PL/SQL block no longer requires a trailing space or new line character for it to work. Updateable bind variables can now be followed directly by commas and parentheses, hence Begin GetName(1, :mybindvar:1024); End; and Begin GetName(:mybindvar:1024, 1); End; both now work. OC/@O/076 Platform(s): All Bind variables of insufficient length passed as OUT parameters in PL/SQL no longer cause a crash. The Server specific keyword ON/OFF has been added that lets you switch trailing spaces on or off in Oracle; it is OFF by default. OC/@O/078FC & PR/@O/036 Platform(s): All The server specific keyword NULLASEMPTY now returns all null values as empty. OC/@O/079 Platform(s): All You can now see table columns when creating an Oracle SQL Ad hoc report (when $sqladhocalltables is set to kTrue). OC/@O/084 Platform(s): All You can now insert and retrieve NULLS from LONG RAW columns in an Oracle database. OC/@O/094FC Platform(s): All Including parentheses in a Select statement, such as (SELECT * FROM TABLE), no longer causes problems when using the Oracle DAM. OC/@O/104 Platform(s): All The 'Describe table' command now returns LONG as Character data with length 10,000,000. In addition, the 'Make file format from table' command creates a Character column with length 10,000,000. OC/@O/105FC Platform(s): Power Mac The Power Mac Oracle DAM now works with the most recent version of SQL*Net 2.3.x and no longer depends on the additional SQL*Net 7.1.4.1.x Required Support Files. CAUTION: please note that in order to make a connection to Oracle from the Power Mac version of OMNIS 7 V3.6.2, you must use SQL*Net V2.3.2.0.0 with Required Support Files V7.3.2.1.1 or later, which fixes Oracle Bug 505203 "Oracle customer can only connect using SQL*Plus," and is available only from Oracle Technical Support (or by way of purchasing the latest version of Developer 2000 from Oracle Corporation). Ensure that you refer to Oracle Bug 505203 when contacting Oracle Technical Support or Oracle Sales and that you receive file "OracleOci73Lib V3.5.2.0.1" or higher in response. (Also see OC/@O/101FC in the Notes and Cautions section below.) OC/@O/106 Platform(s): All Oracle LONG and LONG RAW data types can now be fetched correctly when re-executing the fetch. OC/@O/110 & ST/@O/099 Platform(s): All The Oracle DAM now reads Booleans as numeric values, hence foreign language versions of OMNIS 7 V3.6.2 will now send proper Boolean values to Oracle. OC/@O/111 Platform(s): All You can now use correlation names :old and :new in a create trigger statement. OC/AE/007FC Platform(s): Mac OS The Word Services Apple events in OMNIS 7 V3.6.2 that enable editing tools such as SpellsWell(tm) now work correctly. OC/AH/095 Platform(s): Mac OS Creating an Ad hoc report using an OMNIS 7 data file no longer causes a Type 11 error. OC/CO/211 Platform(s): Mac OS Converting OMNIS 7 V1 applications using V3.6.2 now work correctly. OC/DF/020 & ST/DF/021 Platform(s): All Inserting data into a data file with a locked record no longer corrupts indexes. OC/DF/022 Platform(s): Windows OS OMNIS 7 V3.6.2 applications that run on a server now locate multi-segment data files successfully. OC/EC/133FC Platform(s): Mac OS Clicking the mouse in an external area no longer causes a memory leak. OC/ET/051FC Platform(s): Windows 95 and Windows NT Long file names for ALL external DLLs is now supported. OC/ET/057 Platform(s): All The syntax for the DIROPS commands has reverted back to its V3.5 usage; that is, the listname, columnname, and path parameters can, as before, be enclosed in quotes. OC/ET/065FC Platform(s): Power Mac Path strings longer than 127 characters and up to 255 characters returned using the 'Get Files' command no longer cause a system hang. OC/ET/067FC Platform(s): Power Mac On page 6-45 and 6-93 of the Extending OMNIS manual the description of the fmt_hpict format is misleading. When used with the GetFldVal and SetNamedVal functions you don't need to create the handle yourself, but you should still dispose of the handle. You should pass in a NULL handle, and the handle is created by the function. OC/FU/104FC Platform(s): All The 'Get file read-only attribute' and 'Set file read-only attribute' commands have been added to the FileOps external command package. 'Get file read-only attribute (path, read-flag)' returns the current read-only attribute of the file specified in path. If the read-flag parameter returns kTrue the file is read-only; otherwise if kFalse, the file is read/write. 'Set file read-only attribute (path, read-flag)' lets you set the read-only attribute of the file specified in the path. If you set the read-flag parameter to kTrue the file is set to read-only; or if kFalse, the file is set to read/write. Note that read-only status is the same as locked under Mac OS. Both commands return any error code (documented in the Reference manual), or zero if none. OC/FU/113FC Platform(s): Mac OS The 'Open client import file' command now opens and appends data to an existing import file correctly. OC/FU/114FC Platform(s): Windows OS The 'Retrieve rows to file' command now appends data to the current import file correctly. OC/FU/126 Platform(s): All The dname() function now returns the correct value if the day of the week is a Saturday. OC/HI/804FC Platform(s): Windows 95 You can now move and resize windows when the primary mouse button is set to left-handed usage in the Windows 95 Control Panel. OC/HI/841 Platform(s): Mac OS Using the CTRL key and certain letter keys in OMNIS 7 for Mac OS no longer cause unexpected results. OC/NT/169FC Platform(s): All You can now write the 'Build list from select table' command into procedure text using the notation. In addition the command is not changed at all when you switch to free-type mode in the procedure editor. GR/OL/072 Platform(s): Windows OS Reports containing OLE picture fields now print correctly. In addition OLE picture fields in reports, with the Do not scale option unchecked, are now scaled correctly (Although, please see fault OC/OL/030FC in the Notes and Cautions section below). OC/OL/026 & PR/OL/022FC Platform(s): Windows OS OLE1 objects inserted into an OMNIS 7 data file under Windows 3.1 are now supported in OLE2 under Windows 95. OC/OL/029FC Platform(s): Windows OS Windows are now being redrawn properly when returning to OMNIS 7 from palette applications that use 256 colors. ST/OL/035 & ST/OL/036 Platform(s): Windows 95 Microsoft clip art and Word art 2.0 pictures now display correctly in OMNIS 7. OC/PF/057FC Platform(s): Windows 95 and Windows NT The "OmnisPic.DF1 data file missing" error message no longer appears when you drag-and-drop a library file onto the OMNIS 7 executable in the Windows 95 and Windows NT versions. However, if you drag-and-drop a library file onto the OMNIS 7 executable of a developer instance of OMNIS 7 that is set to load the Developer Shell, please see fault OC/HI/888FC in the Notes and Cautions section below. OC/PF/059 Platform(s): Windows 95 Speed performance has been improved for serial port communications in the Windows 95 version. OC/PF/064 Platform(s): Windows NT only DDE operations no longer cause crashes when using the Windows NT version. OC/PF/066 Platform(s): Mac OS Clicking in the Finder while executing 'Prompt for...' commands no longer causes OMNIS 7 to hang. OC/PF/072 Platform(s): Windows NT v3.51 only Under Windows NT 3.51 only, OMNIS 7 no longer quits when you close the Attributes window for a window object. OC/PF/073 Platform(s): Mac OS Memory and performance problems reported against the OMNIS 3.6.1 Patch for Mac OS no longer occur. OC/RC/255FC Platform(s): Mac OS Screen reports and reports to the printer and are no longer corrupted when you click on the Mac OS menu bar while the report is in progress. OC/RC/271 Platform(s): Windows OS A 'Discard previous settings' check box option has been added to the 'Select printer' command. When checked the page setup for the newly selected printer is always used, otherwise if the option is unchecked the page setup from the previous printer is used (initially this is the default printer). OC/VR/104 Platform(s): All Initial value calculations for local variables are now re-tokenized correctly when formats containing the variables are copied between libraries. OC/VR/109 Platform(s): Windows 3.1 Exponential numbers are now recognized in the Windows 3.1 version. WD/TS/031FC Platform(s): All The TCPReceive command now handles binary data sent to OMNIS 7 via TCP/IP. WD/TS/032FC Platform(s): All The parameter description for the TCPSend command is now (socket, character|binary). 2.3 Faults Fixed in the OMNIS 7.3.6.1 Patch ------------------------------------------------------ This section contains faults fixed in the Macintosh and Power Macintosh versions of OMNIS 7 V3.6. OC/@O/089FC Platform(s): Power Mac The Oracle DAM now closes successfully after using the 'Logoff from host' and 'Quit cursor(s)' commands. OC/PF/055 Platform(s): Mac OS OMNIS 7 v3.6.1 and higher for Mac OS supports Apple's Mac OS 8 operating system. If you are using the DAMs under Mac OS 8 you should contact your clientware vendor(s) to ensure Mac OS 8 compatibility for the respective clientware. OC/PF/061 Platform(s): Mac OS Adding items to the CRB no longer causes a memory leak. OC/PF/068FC Platform(s): Mac OS Memory and performance problems reported against OMNIS 7 V3.6 for Mac OS no longer occur. 3. Notes and Cautions --------------------------- OC/@O/101FC Platform(s): Power Mac There is a memory leak of approximately 64k every time you log on and log off from an Oracle server using the Oracle DAM. This problem is caused by Oracle Bug 569353 contained in the Mac version of SQL*Net 2.3.2.0.0 when connecting using OCI. The fix for this bug is contained in "OracleNetTNSLib V2.3.2.0.2" and is available only from Oracle Technical Support (or by way of purchasing the latest version of Developer 2000 from Oracle Corporation). Ensure that you refer to Oracle Bug 569353 when contacting Oracle Technical Support or Oracle Sales and that you receive file "OracleNetTNSLib V2.3.2.0.2" or higher in response. OC/HI/888FC Platform(s): Windows OS Error messages from the O7DShell.lbr still occur when you drag-and-drop a library file onto the OMNIS 7 executable. Although the fix to OC/PF/057FC eliminates the executable error message "OmnisPic.DF1 data file missing," for all runtime and developer instances of OMNIS 7, the O7DShell.lbr still displays the OMNISPIC.DF1 data file prompt dialog, and if canceled, the error messages: "Because the icons file was not found and opened, certain parts of the Omnis Shell may appear incorrect" and "The icons file could not be opened. This will affect the presentation of the Environment." OC/OL/030FC Platform(s): Windows OS Pictures inserted from PowerPoint are shown a quarter of their correct size, that is, the height and width are each half the correct amount. Other programs, such as Word have the same problem. It appears that PowerPoint is supplying the wrong information, not just to the OMNI2OLE.DLL, but to any program. [END OF FILE]